package com.engineering.elink.recruitdao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.engineering.elink.domain.recruit.Salary;
import com.engineering.elink.vo.recruit.SalaryVo;

public interface SalaryMapper {
    int deleteByPrimaryKey(Integer srId);

    int insert(Salary record);

    int insertSelective(Salary record);

    Salary selectByPrimaryKey(Integer srId);

    int updateByPrimaryKeySelective(Salary record);

    int updateByPrimaryKey(Salary record);
    
    @Select(" select sr_id as srId, sr_name as srName, sequence from salary order by sequence ")
    List<Salary> selectAll();
    
    List<SalaryVo> selectSalaryByLimit(@Param("count")Integer count);
}